yogi_From Timestamp Column Compute Number Of Instances An Entry was Submitted Day By Day

yogi_From Timestamp Column Compute Number Of Instances An Entry was Submitted Day By Day : Sheet1

Published by Google Sheets–Report Abuse–Updated automatically every 5 minutes


1	Timestamp	Date	No of Glasses of Water	spreadsheet locale	question in Google Docs user Forum
2	5/12/2013 19:47:20	1/1/1970	0	United States	http://productforums.google.com/forum/?zx=ch4i4vk7ovi0#!category-topic/docs/spreadsheets/alfGJOScXLs	41406	6
3	5/12/2013 19:52:11					41407	10
4	5/12/2013 18:16:00			this is cell E4		41408	1
5	5/12/2013 21:10:37			formula in cell C2		41409	1
6	5/12/2013 22:18:06			=query(index(if({1,0},A:A,""));"select todate(Col1),count(Col2) where Col1 is not null group by todate(Col1) label todate(Col1) 'Date',count(Col2) 'No of Glasses of Water' ")		42140	1
7	5/12/2013 23:40:55
8	5/13/2013 0:22:31
9	5/13/2013 3:25:28
10	5/13/2013 5:33:58
11	5/13/2013 6:43:10
12	5/13/2013 11:00:50
13	5/13/2013 11:16:39
14	5/13/2013 11:40:32
15	5/13/2013 13:02:53
16	5/13/2013 14:11:31
17	5/13/2013 15:47:10
18	5/14/2013
19	5/15/2013
20	5/16/2015 14:13:00
21
22
23
24